<pre>
<?php
	define("DBNAME", 'cbr.db');
	
	$db = sqlite_open('cbr.db');
	// $query = "PRAGMA table_info(currency_rate)";
	$query = "PRAGMA synchronous=OFF";
	// $query = "PRAGMA journal_size_limit";

	$res = sqlite_query($query ,$db);
	echo $numrows = sqlite_num_rows($res);

	for ($it=0; $it<$numrows; $it++){
		$selection = sqlite_fetch_array($res,SQLITE_ASSOC);
	print_r($selection);
	}
	$query = "PRAGMA synchronous";
	$res = sqlite_query($query ,$db);
	echo $numrows = sqlite_num_rows($res);
	for ($it=0; $it<$numrows; $it++){
		$selection = sqlite_fetch_array($res,SQLITE_ASSOC);
	print_r($selection);
	}
	sqlite_close($db);
	
?>
</pre>